USDA Data Sources

Data steward(s):

  • Lisa Jackson (lisa.jackson@usda.gov)
  • Lea Timms (leanne.tims@usda.gov)
  • sm.nass.data.lab@usda.gov
  • David Dudgeon (david.dudgeon@usda.gov)

Coleridge Project Manager

  • Ernesto Gimeno (ernesto.gimeno@coleridgeinitiative.org)
  • Jon Mills (jon.mills@coleridgeinitiative.org)

Redshift Data (ds_usda_* schemas)

Schema Table Last Updated Frequency Notes
ds_usda_aphis_ppq ean2010_2020 APHIS Plant Protection and Quarantine emergency action notification data 2010-2020 |
ds_usda_aphis_ppq import2010_2020 APHIS PPQ import data 2010-2020 |
ds_usda_aphis_ppq pest2010_2020 APHIS PPQ pest data 2010-2020 |
ds_usda_aphis_ppq wads2010_2020 APHIS PPQ Weeds and Seeds data 2010-2020 |
ds_usda_circana demo Circana consumer demographics data
ds_usda_circana iriweek Circana IRI week reference data
ds_usda_circana medprofiler Circana media profiler data
ds_usda_circana pd_hh_master_2019 Circana household master data 2019 |
ds_usda_circana pd_hh_pos_rw_2019 Circana household POS random weight 2019 |
ds_usda_circana pd_master Circana product master data
ds_usda_circana pd_master_2022 Circana product master 2022 |
ds_usda_circana pd_master_2023 Circana product master 2023 |
ds_usda_circana pd_nutr Circana product nutrition data
ds_usda_circana pd_perish Circana perishable product data
ds_usda_circana pd_pl Circana private label product data
ds_usda_circana pd_pos Circana point-of-sale product data
ds_usda_circana pd_pos_rw Circana POS random weight data
ds_usda_circana pd_rwpanel Circana random weight panel data
ds_usda_circana pos_rma Circana POS regional market area data
ds_usda_circana pos_rw_rma Circana POS random weight RMA data
ds_usda_circana pos_rw_rma_deprecated Circana POS RW RMA deprecated data
ds_usda_circana pos_rw_store Circana POS random weight store data
ds_usda_circana pos_rw_store_deprecated Circana POS RW store deprecated data
ds_usda_circana pos_rw_walmart_cma Circana POS RW Walmart CMA data
ds_usda_circana pos_store Circana point-of-sale store data
ds_usda_circana privatelabel_rma Circana private label RMA data
ds_usda_circana privatelabel_store Circana private label store data
ds_usda_circana rma_info Circana regional market area information
ds_usda_circana rma_info_deprecated Circana RMA info deprecated
ds_usda_circana rw_rma Circana random weight RMA data
ds_usda_circana rw_store Circana random weight store data
ds_usda_circana rxpulse Circana prescription pulse data
ds_usda_circana store_info Circana store information
ds_usda_circana store_info_deprecated Circana store info deprecated
ds_usda_circana trip Circana consumer trip data
ds_usda_circana trip_tbv Circana trip total basket value data
ds_usda_circana walmart_cma_rma_info Circana Walmart CMA RMA information
ds_usda_iri demo_all Yearly | IRI consumer demographics - all years |
ds_usda_iri iriweek_all IRI week reference - all years |
ds_usda_iri medprofiler_all IRI media profiler - all years |
ds_usda_iri pd_master_all IRI product master - all years |
ds_usda_iri pd_nutr_all IRI product nutrition - all years |
ds_usda_iri pd_perish_all IRI perishable products - all years |
ds_usda_iri pd_pl_all IRI private label products - all years |
ds_usda_iri pd_pl_tst IRI private label test data
ds_usda_iri pd_pos_all IRI point-of-sale products - all years |
ds_usda_iri pd_rwpanel IRI random weight panel data
ds_usda_iri pl_rma_all IRI private label RMA - all years |
ds_usda_iri pl_store_all IRI private label store - all years |
ds_usda_iri pos_rma_all IRI POS RMA - all years |
ds_usda_iri pos_store_all_2008 IRI POS store 2008 |
ds_usda_iri pos_store_all_2009 IRI POS store 2009 |
ds_usda_iri pos_store_all_2010 IRI POS store 2010 |
ds_usda_iri pos_store_all_2011 IRI POS store 2011 |
ds_usda_iri pos_store_all_2012 IRI POS store 2012 |
ds_usda_iri pos_store_all_2013 IRI POS store 2013 |
ds_usda_iri pos_store_all_2014 IRI POS store 2014 |
ds_usda_iri pos_store_all_2015 IRI POS store 2015 |
ds_usda_iri pos_store_all_2016 IRI POS store 2016 |
ds_usda_iri pos_store_all_2017 IRI POS store 2017 |
ds_usda_iri pos_store_all_2018 IRI POS store 2018 |
ds_usda_iri ppc2015 IRI PPC (Personal Product Code) 2015 |
ds_usda_iri ppc20152016 IRI PPC 2015-2016 |
ds_usda_iri ppc20172018 IRI PPC 2017-2018 |
ds_usda_iri ppc_linkingdatabase_2013 IRI PPC linking database 2013 |
ds_usda_iri ppc_pos_cf_2013 IRI PPC POS convenience food 2013 |
ds_usda_iri ppc_rw_cf_2013 IRI PPC random weight convenience food 2013 |
ds_usda_iri privatelabel_rma_all IRI private label RMA - all years |
ds_usda_iri privatelabel_store_all IRI private label store - all years |
ds_usda_iri rma_info_all IRI RMA information - all years |
ds_usda_iri rw_rma_all IRI random weight RMA - all years |
ds_usda_iri rw_rma_all_no_kroger IRI RW RMA all excluding Kroger |
ds_usda_iri rw_store_all IRI random weight store - all years |
ds_usda_iri rxpulse_all IRI prescription pulse - all years |
ds_usda_iri store_info_all IRI store information - all years |
ds_usda_iri store_info_all_2018_dupes IRI store info 2018 duplicates |
ds_usda_iri trip_all IRI consumer trip data - all years |
ds_usda_iri trip_tbv_all IRI trip total basket value - all years |
ds_usda_iri vw_pos_store_all IRI POS store view - all years |
ds_usda_iri_2019_2023 demo_2019 1 December 2023 Yearly | IRI consumer demographics 2019 |
ds_usda_iri_2019_2023 demo_2020 1 December 2023 Yearly | IRI consumer demographics 2020 |
ds_usda_iri_2019_2023 demo_2021 1 December 2023 Yearly | IRI consumer demographics 2021 |
ds_usda_iri_2019_2023 demo_2022 1 December 2023 Yearly | IRI consumer demographics 2022 |
ds_usda_iri_2019_2023 demo_2023 1 December 2023 Yearly | IRI consumer demographics 2023 |
ds_usda_iri_2019_2023 iriweek IRI week reference 2019-2023 |
ds_usda_iri_2019_2023 medprofiler_2019 IRI media profiler 2019 |
ds_usda_iri_2019_2023 medprofiler_2020 IRI media profiler 2020 |
ds_usda_iri_2019_2023 medprofiler_2021 IRI media profiler 2021 |
ds_usda_iri_2019_2023 medprofiler_2022 IRI media profiler 2022 |
ds_usda_iri_2019_2023 medprofiler_2023 IRI media profiler 2023 |
ds_usda_iri_2019_2023 pd_hh_master_2019 IRI household master 2019 |
ds_usda_iri_2019_2023 pd_hh_pos_rw_2019 IRI household POS random weight 2019 |
ds_usda_iri_2019_2023 pd_master_2019 IRI product master 2019 |
ds_usda_iri_2019_2023 pd_master_2020 IRI product master 2020 |
ds_usda_iri_2019_2023 pd_master_2021 IRI product master 2021 |
ds_usda_iri_2019_2023 pd_master_2022 IRI product master 2022 |
ds_usda_iri_2019_2023 pd_master_2023 IRI product master 2023 |
ds_usda_iri_2019_2023 pd_pl_2019 IRI private label products 2019 |
ds_usda_iri_2019_2023 pd_pl_2020 IRI private label products 2020 |
ds_usda_iri_2019_2023 pd_pl_2021 IRI private label products 2021 |
ds_usda_iri_2019_2023 pd_pl_2022 IRI private label products 2022 |
ds_usda_iri_2019_2023 pd_pl_2023 IRI private label products 2023 |
ds_usda_iri_2019_2023 pd_pos_rw_2019 IRI POS random weight products 2019 |
ds_usda_iri_2019_2023 pd_pos_rw_2020 IRI POS random weight products 2020 |
ds_usda_iri_2019_2023 pd_pos_rw_2021 IRI POS random weight products 2021 |
ds_usda_iri_2019_2023 pd_pos_rw_2022 IRI POS random weight products 2022 |
ds_usda_iri_2019_2023 pd_pos_rw_2023 IRI POS random weight products 2023 |
ds_usda_iri_2019_2023 pd_rwpanel IRI random weight panel 2019-2023 |
ds_usda_iri_2019_2023 pos_rw_rma_2019 IRI POS random weight RMA 2019 |
ds_usda_iri_2019_2023 pos_rw_rma_2019_deprecated IRI POS RW RMA 2019 deprecated |
ds_usda_iri_2019_2023 pos_rw_rma_2020 IRI POS random weight RMA 2020 |
ds_usda_iri_2019_2023 pos_rw_rma_2021 IRI POS random weight RMA 2021 |
ds_usda_iri_2019_2023 pos_rw_rma_2022 IRI POS random weight RMA 2022 |
ds_usda_iri_2019_2023 pos_rw_rma_2023 IRI POS random weight RMA 2023 |
ds_usda_iri_2019_2023 pos_rw_store_2019 IRI POS random weight store 2019 |
ds_usda_iri_2019_2023 pos_rw_store_2019_deprecated IRI POS RW store 2019 deprecated |
ds_usda_iri_2019_2023 pos_rw_store_2020 IRI POS random weight store 2020 |
ds_usda_iri_2019_2023 pos_rw_store_2021 IRI POS random weight store 2021 |
ds_usda_iri_2019_2023 pos_rw_store_2022 IRI POS random weight store 2022 |
ds_usda_iri_2019_2023 pos_rw_store_2023 IRI POS random weight store 2023 |
ds_usda_iri_2019_2023 pos_rw_walmart_cma_2019 IRI POS RW Walmart CMA 2019 |
ds_usda_iri_2019_2023 pos_rw_walmart_cma_2020 IRI POS RW Walmart CMA 2020 |
ds_usda_iri_2019_2023 privatelabel_rma_2019 IRI private label RMA 2019 |
ds_usda_iri_2019_2023 privatelabel_rma_2020 IRI private label RMA 2020 |
ds_usda_iri_2019_2023 privatelabel_rma_2021 IRI private label RMA 2021 |
ds_usda_iri_2019_2023 privatelabel_rma_2022 IRI private label RMA 2022 |
ds_usda_iri_2019_2023 privatelabel_rma_2023 IRI private label RMA 2023 |
ds_usda_iri_2019_2023 rma_info_2019 IRI RMA information 2019 |
ds_usda_iri_2019_2023 rma_info_2020 IRI RMA information 2020 |
ds_usda_iri_2019_2023 rma_info_2021 IRI RMA information 2021 |
ds_usda_iri_2019_2023 rma_info_2022 IRI RMA information 2022 |
ds_usda_iri_2019_2023 rma_info_2023 IRI RMA information 2023 |
ds_usda_iri_2019_2023 rma_info_deprecated IRI RMA info deprecated
ds_usda_iri_2019_2023 rxpulse_2019 IRI prescription pulse 2019 |
ds_usda_iri_2019_2023 rxpulse_2020 IRI prescription pulse 2020 |
ds_usda_iri_2019_2023 rxpulse_2021 IRI prescription pulse 2021 |
ds_usda_iri_2019_2023 rxpulse_2022 IRI prescription pulse 2022 |
ds_usda_iri_2019_2023 rxpulse_2023 IRI prescription pulse 2023 |
ds_usda_iri_2019_2023 store_info_2019 IRI store information 2019 |
ds_usda_iri_2019_2023 store_info_2020 IRI store information 2020 |
ds_usda_iri_2019_2023 store_info_2021 IRI store information 2021 |
ds_usda_iri_2019_2023 store_info_2022 IRI store information 2022 |
ds_usda_iri_2019_2023 store_info_2023 IRI store information 2023 |
ds_usda_iri_2019_2023 store_info_deprecated IRI store info deprecated
ds_usda_iri_2019_2023 trip_2019 IRI consumer trip data 2019 |
ds_usda_iri_2019_2023 trip_2020 IRI consumer trip data 2020 |
ds_usda_iri_2019_2023 trip_2021 IRI consumer trip data 2021 |
ds_usda_iri_2019_2023 trip_2022 IRI consumer trip data 2022 |
ds_usda_iri_2019_2023 trip_2023 IRI consumer trip data 2023 |
ds_usda_iri_2019_2023 trip_tbv_2019 IRI trip total basket value 2019 |
ds_usda_iri_2019_2023 trip_tbv_2020 IRI trip total basket value 2020 |
ds_usda_iri_2019_2023 trip_tbv_2021 IRI trip total basket value 2021 |
ds_usda_iri_2019_2023 trip_tbv_2022 IRI trip total basket value 2022 |
ds_usda_iri_2019_2023 trip_tbv_2023 IRI trip total basket value 2023 |
ds_usda_iri_2019_2023 walmart_cma_rma_info IRI Walmart CMA RMA information
ds_usda_nets moveyear2019 NETS business move year 2019 |
ds_usda_nets naics17_19 NETS NAICS codes 2017-2019 |
ds_usda_nets nets21_2010_census_block_xwalk NETS 2021 to 2010 census block crosswalk |
ds_usda_nets nets21_2020_census_block_xwalk NETS 2021 to 2020 census block crosswalk |
ds_usda_nets nets_2015_census_block_xwalk NETS 2015 census block crosswalk |
ds_usda_nets nets_2021_addressfirst NETS 2021 first address data |
ds_usda_nets nets_2021_company NETS 2021 company information |
ds_usda_nets nets_2021_emp NETS 2021 employment data |
ds_usda_nets nets_2021_fips NETS 2021 FIPS codes |
ds_usda_nets nets_2021_hqcompany NETS 2021 headquarters company data |
ds_usda_nets nets_2021_hqs NETS 2021 headquarters information |
ds_usda_nets nets_2021_misc NETS 2021 miscellaneous data |
ds_usda_nets nets_2021_move NETS 2021 business moves |
ds_usda_nets nets_2021_movesummary NETS 2021 move summary data |
ds_usda_nets nets_2021_naics17 NETS 2021 NAICS 2017 codes |
ds_usda_nets nets_2021_ratings NETS 2021 business ratings |
ds_usda_nets nets_2021_sales NETS 2021 sales data |
ds_usda_nets nets_2021_sic NETS 2021 SIC codes |
ds_usda_nets nets_2022_addressfirst NETS 2022 first address data |
ds_usda_nets nets_2022_company NETS 2022 company information |
ds_usda_nets nets_2022_emp NETS 2022 employment data |
ds_usda_nets nets_2022_fips NETS 2022 FIPS codes |
ds_usda_nets nets_2022_hqcompany NETS 2022 headquarters company data |
ds_usda_nets nets_2022_hqs NETS 2022 headquarters information |
ds_usda_nets nets_2022_misc NETS 2022 miscellaneous data |
ds_usda_nets nets_2022_move NETS 2022 business moves |
ds_usda_nets nets_2022_movesummary NETS 2022 move summary data |
ds_usda_nets nets_2022_naics22 NETS 2022 NAICS 2022 codes |
ds_usda_nets nets_2022_ratings NETS 2022 business ratings |
ds_usda_nets nets_2022_sales NETS 2022 sales data |
ds_usda_nets nets_2022_sic NETS 2022 SIC codes |
ds_usda_nets netsdata2019 NETS database 2019 comprehensive data |
ds_usda_safegraph coi_patterns SafeGraph Core Places patterns data
ds_usda_safegraph core_poi SafeGraph Core Points of Interest data |
ds_usda_nass arms_corn_1996 Periodic | Agricultural Resource Management Survey - Corn 1996 |
ds_usda_nass arms_generic Annual | ARMS generic cross-commodity data |
ds_usda_nass census_agriculture_1997 Quinquennial | Census of Agriculture 1997 |
ds_usda_nass census_agriculture_2002 Quinquennial | Census of Agriculture 2002 |
ds_usda_nass census_agriculture_2007 Quinquennial | Census of Agriculture 2007 |
ds_usda_nass census_agriculture_2012 Quinquennial | Census of Agriculture 2012 |
ds_usda_nass census_agriculture_2017 Quinquennial | Census of Agriculture 2017 |
ds_usda_nass census_agriculture_2022 Quinquennial | Census of Agriculture 2022 (preliminary) |
ds_usda_ers foodaps_group1 Final One-time | Food Acquisition and Purchase Survey Group 1 data (2012-2013) |
ds_usda_ers foodaps_group2 Final One-time | Food Acquisition and Purchase Survey Group 2 data (2012-2013) |
ds_usda_ers foodaps_group3 Final One-time | Food Acquisition and Purchase Survey Group 3 data (2012-2013) |
ds_usda_ers foodaps_group4 Final One-time | Food Acquisition and Purchase Survey Group 4 data (2012-2013) |
ds_usda_ers foodaps_group5 Final One-time | Food Acquisition and Purchase Survey Group 5 data (2012-2013) |
ds_usda_ers foodaps_group6 Final One-time | Food Acquisition and Purchase Survey Group 6 data (2012-2013) |
ds_usda_ers foodaps_group7 Final One-time | Food Acquisition and Purchase Survey Group 7 data (2012-2013) |

G: Drive Data (USDA Survey and Research Files)

G Drive Location Dataset Last Updated Frequency Notes
G:/USDA_Agricultural_Productivity agricultural_productivity Annual Comprehensive agricultural productivity measures and analysis
G:/USDA_AMS_Daily_Closures_Reductions_By_Slaughter_Plant | daily_closures_reductions | | Daily | Agricultural Marketing Service daily slaughter plant operations data |
G:/USDA_APHIS_NAHMS_Bison_Srvy | bison_survey | | Periodic | National Animal Health Monitoring System bison survey data |
G:/USDA_APHIS_NAHMS_Sheep_Srvy | sheep_survey | | Periodic | National Animal Health Monitoring System sheep survey data |
G:/USDA_APHIS_Turkey_Srvy | turkey_survey | | Periodic | Animal and Plant Health Inspection Service turkey industry survey |
G:/USDA_ARMS/native/ARMS_III_generic | arms_generic | | Annual | Agricultural Resource Management Survey Phase III generic data |
G:/USDA_ARMS/native/ARMS_crop_specific | arms_crop_specific | | Annual | Crop-specific ARMS data covering major commodities from 1996-2021 |
G:/USDA_Census_of_Agriculture | census_agriculture | | Quinquennial | Complete enumeration of US farms and ranches and the people who operate them
G:/USDA_Census_of_Aquaculture | census_aquaculture | | Quinquennial | Census data for aquaculture operations in the United States
G:/USDA_ChemUse_Program chemical_use Periodic Agricultural chemical use data for crops and livestock
G:/USDA_Crop_Insurance crop_insurance Annual Federal crop insurance program participation and claims data
G:/USDA_Feral_Swine_Crop_Srvy | feral_swine_crop | | Periodic | Survey of crop damage from feral swine populations |
G:/USDA_Feral_Swine_Livestock_Srvy | feral_swine_livestock | | Periodic | Survey of livestock impacts from feral swine populations |
G:/USDA_FoodAPS/native | foodaps_native | | One-time | Food Acquisition and Purchase Survey native format data (2012-2013) |
G:/USDA_Fruit_Chemical_Use_Srvy | fruit_chemical_use | | Periodic | Chemical use survey for fruit crop production |
G:/USDA_IL_Beef_Biosecurity_Srvy | il_beef_biosecurity | | Periodic | Illinois beef production biosecurity practices survey |
G:/USDA_Iowa_Commercial_Horticulture_for_Food_Crops_Srvy | ia_commercial_horticulture | | Periodic | Iowa commercial food crop horticulture operations survey |
G:/USDA_IRI_Pandemic_Response | iri_pandemic_response | | Periodic | IRI consumer purchase data during COVID-19 pandemic response |
G:/USDA_IRI_weights | iri_weights | | As needed | IRI data weighting factors and methodology |
G:/USDA_Irrigation_Water_Management_Srvy | irrigation_water_management | | Periodic | Survey of on-farm irrigation water management practices |
G:/USDA_Local_Food_Marketing_Practices | local_food_marketing | | Periodic | Local and regional food marketing practices survey |
G:/USDA_MN_Pesticide_Fertilizer_BPM | mn_pesticide_fertilizer | | Periodic | Minnesota pesticide and fertilizer best practices management |
G:/USDA_MO_Deer_Assesssment_Srvy | mo_deer_assessment | | Periodic | Missouri deer population assessment and impact survey |
G:/USDA_MS_Cropping_Practices_Srvy | ms_cropping_practices | | Periodic | Mississippi cropping practices and management survey |
G:/USDA_MS_Extension_Cost_Prod_and_Srvy | ms_extension_cost_production | | Periodic | Mississippi Extension cost of production survey |
G:/USDA_NASS_Conservation_Effects_Assessment_Project_Srvy | nass_ceap | | Periodic | Conservation Effects Assessment Project survey data |
G:/USDA_NASS_OSU_Land_leasing | nass_osu_land_leasing | | Periodic | NASS-Ohio State University land leasing rates and practices |
G:/USDA_NASS_Vegetable_Srvy | nass_vegetable | | Annual | National Agricultural Statistics Service vegetable production survey |
G:/USDA_National_Agroforestry_Srvy | national_agroforestry | | Periodic | National survey of agroforestry practices and adoption |
G:/USDA_Nets_Data_Projects | nets_projects | | As needed | Business establishment data projects using National Establishment Time Series |
G:/USDA_Nielsen_Homescan | nielsen_homescan | | Continuous nielsen_homescan | | Continuous | Nielsen Homescan consumer purchase tracking data |
G:/USDA_NIS | nis | | As needed | National Information Systems data |
G:/USDA_Non_Irrigated_Cropland_Srvy | non_irrigated_cropland | | Periodic | Non-irrigated cropland management practices survey |
G:/USDA_NPD | npd | | Continuous npd | | Continuous | NPD Group consumer purchase tracking data |
G:/USDA_NRCS_CPAMS_CROP_Practices | nrcs_cpams_crop | | Annual | Natural Resources Conservation Service Conservation Practice Adoption Monitoring System - crop practices |
G:/USDA_NRCS_CPAMS_Confined_Livestock_Practices | nrcs_cpams_livestock | | Annual | NRCS CPAMS confined livestock practices data |
G:/USDA_NRCS_CPAMS_Pilot_Data | nrcs_cpams_pilot | | Pilot | NRCS CPAMS pilot program data |
G:/USDA_OFREPS | ofreps | | As needed | Organic Field Research and Extension Partnership System data |
G:/USDA_OK_Beef_Management_Srvy | ok_beef_management | | Periodic | Oklahoma beef management practices survey |
G:/USDA_Organic_Srvy | organic_survey | | Periodic | National organic agriculture survey data |
G:/USDA_ReCount | recount | | As needed | Retail establishment count and characteristics data |
G:/USDA_RUS | rus | | As needed | Rural Utilities Service data |
G:/USDA_SafeGraph_Places_Patterns | safegraph_places_patterns | | Monthly | SafeGraph Places and Patterns location intelligence data |
G:/USDA_Srvy_Irrigation_Organizations | irrigation_organizations | | Periodic | Survey of irrigation organizations and water management entities |
G:/USDA_TDLinx | tdlinx | | Annual | TDLinx retail establishment database |
G:/USDA_TOTAL | total | | As needed | TOTAL farm management information system data |
G:/USDA_Vegetable_Chemical_Use_Srvy | vegetable_chemical_use | | Periodic | Chemical use survey for vegetable crop production |